Freelog Special Freeware 31/FreelogHS31.iso/ArgentCompta/FASTCOMPTA/Setup FASTCOMPTA.exe/{app}/description.sql

Text File | 2006-12-11 | 31KB | 756 lines

/******************************************************************************/
/****                             Descriptions                             ****/
/******************************************************************************/

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Usage interne: Contient divers fichiers binaires'
WHERE (RDB$RELATION_NAME = 'BLOBS');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Fichier des comptes gΘnΘraux et des comptes tiers/auxilliaire'
WHERE (RDB$RELATION_NAME = 'COMPTES');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Stocke les ΘlΘments utilisΘs pour la numΘrotation automatique des Θcritures d''un journal'
WHERE (RDB$RELATION_NAME = 'COMPTEUR');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Stocke les modΦles d''Θtats utilisΘs par FastCompta'
WHERE (RDB$RELATION_NAME = 'ETATS');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Table des exercices comptables'
WHERE (RDB$RELATION_NAME = 'EXERCICE');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Table des journaux comptables'
WHERE (RDB$RELATION_NAME = 'JOURNAL');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Table des valeurs mensuelles attachΘes α un journal'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Description d''une ligne d''Θcriture'
WHERE (RDB$RELATION_NAME = 'LIGNES');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Usage interne. Sert essentiellement α imprimer les tables affichΘes dans FastCompta. Le logiciel gΘnΦre la liste des lignes, et le gΘnΘrateur d''Θtat va lire cette liste.'
WHERE (RDB$RELATION_NAME = 'LISTE');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Tables des modΦles d''Θcritures'
WHERE (RDB$RELATION_NAME = 'MODELES');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Table des mouvements. Un mouvement est un groupe d''Θcritures ayant un solde nul (crΘdit=dΘbit) '
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Usage interne. Stocke divers rΘglages de l''interface communs α tous les postes: cases α cocher, index de listes, etc...'
WHERE (RDB$RELATION_NAME = 'PREFERENCES');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Stocke les fiches tiers. La fiche d''index 1 est celle de l''entreprise.'
WHERE (RDB$RELATION_NAME = 'TIERS');

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'Taux de TVA'
WHERE (RDB$RELATION_NAME = 'TVA');



/******************************************************************************/
/****                             Descriptions                             ****/
/******************************************************************************/

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'Returns the absolute value of a number.'
WHERE (RDB$FUNCTION_NAME = 'ABS');

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'Returns the ASCII character corresponding with the value passed in.'
WHERE (RDB$FUNCTION_NAME = 'ASCII_CHAR');

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'Returns the ascii value of the character passed in.'
WHERE (RDB$FUNCTION_NAME = 'ASCII_VAL');

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'Returns the length of a given string.'
WHERE (RDB$FUNCTION_NAME = 'STRLEN');

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'substr(s,m,n) returns the substring
of s which starts at position m and
ending at position n.'
WHERE (RDB$FUNCTION_NAME = 'SUBSTR');

UPDATE RDB$FUNCTIONS
SET RDB$DESCRIPTION = 'substr(s,i,l) returns the substring
of s which starts at position i and
ends at position i+l-1, being l the length.'
WHERE (RDB$FUNCTION_NAME = 'SUBSTRLEN');



/******************************************************************************/
/****                             Descriptions                             ****/
/******************************************************************************/

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le solde des comptes associΘs aux journaux mensuels'
WHERE (RDB$PROCEDURE_NAME = 'ALL_SOLDE_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le total d''un compte dans le Journal ''A Nouveau'''
WHERE (RDB$PROCEDURE_NAME = 'A_NOUVEAU_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Cette procΘdure retourne la balance des comptes.'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_DES_COMPTES');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le solde d''un compte pour un exercice.'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_UN_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Met α jour le champ VERROU pour un compte. VERROU=0 si pas de lignes d''Θcritures, n sinon. GΘnΦre un ΘvΦnement'
WHERE (RDB$PROCEDURE_NAME = 'CALCUL_VERROU_UN_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'VΘrifie les cohΘrences des gΘnΘrateurs, et retourne une information sur les ajustements.'
WHERE (RDB$PROCEDURE_NAME = 'CHECK_GENPK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Cette procΘdure fait partie du processus de cl⌠ture d''un exercice.
On compare deux mouvements A Nouveau dans l''exercice N,
on recopie les lettrages du mouvement 1 dans le 2,
et on efface les autres.
Sert lorsque l''on recalcul les A Nouveaux aprΦs modification d''un exercice antΘrieur.
Ceci permet de lettrer les comptes A Nouveau dans l''exercice sans cloturer N-1'
WHERE (RDB$PROCEDURE_NAME = 'COPIE_LETTRAGE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Efface un modΦle d''Θtat et le blob associΘ'
WHERE (RDB$PROCEDURE_NAME = 'EFFACE_MODELE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Efface un compte s''il ne contient pas de lignes d''Θcriture, ainsi que les comptes fils.'
WHERE (RDB$PROCEDURE_NAME = 'EFF_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Indique si un compte peut-Ωtre effacΘ car sans ligne d''Θcriture'
WHERE (RDB$PROCEDURE_NAME = 'EFF_COMPTE_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Indique si un exercice peut-Ωtre effacΘ car sans ligne d''Θcriture'
WHERE (RDB$PROCEDURE_NAME = 'EFF_EXERCICE_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Effacer un journal'
WHERE (RDB$PROCEDURE_NAME = 'EFF_JOURNAL_MOIS');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Indique si un journal peut-Ωtre effacΘ car sans ligne d''Θcriture'
WHERE (RDB$PROCEDURE_NAME = 'EFF_JOURNAL_MOIS_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Indique si un journal peut-Ωtre effacΘ car sans ligne d''Θcriture'
WHERE (RDB$PROCEDURE_NAME = 'EFF_JOURNAL_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne 1 si aucun compte de la liste LISTE n''est dans un mouvement verrouillΘ'
WHERE (RDB$PROCEDURE_NAME = 'EFF_LISTE_COMPTE_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Efface un mouvement (s''il n''est pas verrouillΘ). Retourne 1 si l''effacement a ΘtΘ fait.'
WHERE (RDB$PROCEDURE_NAME = 'EFF_MOUVEMENT');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'EXPORT_ADRESSE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'EXPORT_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'EXPORT_COMPTES');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'A complΘter'
WHERE (RDB$PROCEDURE_NAME = 'EXPORT_TIERS');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'EXPORT_TVA');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne la liste des Θcriture d''un compte gΘnΘral ou tiers. Ne regroupe pas les comptes.'
WHERE (RDB$PROCEDURE_NAME = 'EXTRAIT_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Cherche l''index du compte principal et secondaire attachΘs aux libellΘs passΘs en entrΘe.
Sert essentiellement lors de l''insertion des lignes.'
WHERE (RDB$PROCEDURE_NAME = 'GET_INDEXS_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne l''index d''un journal mensuel'
WHERE (RDB$PROCEDURE_NAME = 'GET_INDEX_JM');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Cherche l''index du compte dΘfini par les deux libellΘs passΘs en paramΦtres'
WHERE (RDB$PROCEDURE_NAME = 'GET_INDX_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Recherche le premier lettrage utilisable pour un compte donnΘ.
Note: En environnement multi-utilisateurs, il est possible (mais trΦs improbable)
que deux utilisateurs utilisent la mΩme lettre pour lettrer un mΩme compte.
Ceci n''Θtant pas vraiment gΩnant, j''ai laissΘ le lettrage des lignes dans l''application.
L''autre solution aurait ΘtΘ de faire une PS utilisant la table LISTE pour lettrer
un compte, avec calcul de la chaεne de lettrage en entrΘe de PS.'
WHERE (RDB$PROCEDURE_NAME = 'GET_LETTRAGE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le nom d''un compte'
WHERE (RDB$PROCEDURE_NAME = 'GET_LIB_COURTS');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Donne l''ID lettrage suivante.
A->B
Z -> AA
AZ -> BA
ZZ -> AAA
ABZ -> ACA
etc... jusqu''α ZZZZ'
WHERE (RDB$PROCEDURE_NAME = 'GET_NEXT_LETTRAGE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le libellΘ complet du compte'
WHERE (RDB$PROCEDURE_NAME = 'GET_NOM_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le nom du compte ou du compte de regroupement'
WHERE (RDB$PROCEDURE_NAME = 'GET_NOM_COMPTE_GENERAL');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Calcul le solde du dΘbut de mois d''un compte ratachΘ α un journal'
WHERE (RDB$PROCEDURE_NAME = 'GET_REPORT_JM_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le total crΘditeur d''un journal mensuel'
WHERE (RDB$PROCEDURE_NAME = 'GET_SOLDE_JOURNAL');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne le grand-livre regroupΘ (pas de dΘtail des tiers) de l''exercice'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'IMPORT_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Usage interne'
WHERE (RDB$PROCEDURE_NAME = 'IMPORT_TVA');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Interrogation des Θcritures entre deux dates'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Liste des Θcritures d''un compte (regroupΘe)'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_CPT');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Liste des Θcritures d''un Journal'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_JL');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Liste des Θcritures d''un mouvement'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_MVT');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Indique si un mouvement est verrouillΘ   (1=Oui)'
WHERE (RDB$PROCEDURE_NAME = 'IS_EFF_MOUVEMENT_OK');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Retourne la liste des comptes avec les tiers'
WHERE (RDB$PROCEDURE_NAME = 'LISTE_COMPTES');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'ProcΘdure interne. Met α jour le champ MOUVEMENTS.IMPAIRE servant α dΘfinir la couleur de fond dans la liste des mouvements'
WHERE (RDB$PROCEDURE_NAME = 'SET_IMPAIRE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Met α jour le solde mensuel d''un journal'
WHERE (RDB$PROCEDURE_NAME = 'SOLDE_JM_COMPTE');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Cl⌠ture un journal si tous les mouvements sont totalement verrouillΘs'
WHERE (RDB$PROCEDURE_NAME = 'UPDATE_DATE_CLOTURE_JM');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Verrouille un journal'
WHERE (RDB$PROCEDURE_NAME = 'VERROUILLE_JM');

UPDATE RDB$PROCEDURES
SET RDB$DESCRIPTION = 'Verrouille un mouvement (et le journal s''il est totalement verrouillΘ)'
WHERE (RDB$PROCEDURE_NAME = 'VERROUILLE_MVT');



/******************************************************************************/
/****                             Descriptions                             ****/
/******************************************************************************/

UPDATE RDB$EXCEPTIONS
SET RDB$DESCRIPTION = 'Indique que le compte possΦde plus de 475 253  lettrages.
Etonnant, non ?'
WHERE (RDB$EXCEPTION_NAME = 'OUT_OF_LETTRES');



/* Fields descriptions */

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du blob'
WHERE (RDB$RELATION_NAME = 'BLOBS') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Fichier binaire.'
WHERE (RDB$RELATION_NAME = 'BLOBS') AND (RDB$FIELD_NAME = 'BINAIRE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du compte'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'LibellΘ du compte suivant le plan comptable (exemple: 411000 )
ou
LibellΘ du compte auxilliaire/Tiers'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'LIB_COURT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Description de la nature du compte'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'LIB_LONG');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de la fiche client/Fournisseur (->TIERS.INDX) ou Null si pas de fiche.'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'INDX_TIERS');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Null: Compte principal
sinon, index du compte principal auquel est ratachΘ ce compte auxilliaire ( -> COMPTE.INDX)'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'REGROUPEMENT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de la  TVA ( -> TVA.IINDX) auquel est rattachΘ ce compte (normalement classe 6 ou 7).
FastCompta utilise ce champ pour calculer la TVA α partir des sommes HT'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'INDX_TVA');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne (NΘcessaire au respect de la directive 13 L-1-106) . Ne pas modifier ce champ.'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'VERROU');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Compte α utiliser de prΘfΘrence comme contrepartie'
WHERE (RDB$RELATION_NAME = 'COMPTES') AND (RDB$FIELD_NAME = 'CONTREPARTIE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''exercice ( -> EXERCICE.INDX)'
WHERE (RDB$RELATION_NAME = 'COMPTEUR') AND (RDB$FIELD_NAME = 'INDX_EXERCICE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du journal concernΘ par ce rΘglage ( -> JOURNAL.INDX)'
WHERE (RDB$RELATION_NAME = 'COMPTEUR') AND (RDB$FIELD_NAME = 'INDX_JOURNAL');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Chaεne placΘe avant le numΘro'
WHERE (RDB$RELATION_NAME = 'COMPTEUR') AND (RDB$FIELD_NAME = 'PREFIXE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Chaεne placΘe aprΦs le numΘro'
WHERE (RDB$RELATION_NAME = 'COMPTEUR') AND (RDB$FIELD_NAME = 'SUFFIXE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'IncrΘment du numΘro par Θcriture.
Note: La valeur du compteur est stockΘe dans les gΘnΘrateurs de la base sous la forme
GEN_n1_n2
n1: index de l''exercice
n2: index du journal'
WHERE (RDB$RELATION_NAME = 'COMPTEUR') AND (RDB$FIELD_NAME = 'INCREMENT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''Θtat'
WHERE (RDB$RELATION_NAME = 'ETATS') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Nom complet de l''Θtat'
WHERE (RDB$RELATION_NAME = 'ETATS') AND (RDB$FIELD_NAME = 'NOM');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Fichier binaire stockant l''Θtat'
WHERE (RDB$RELATION_NAME = 'ETATS') AND (RDB$FIELD_NAME = 'FRF');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Fonction dans FastCompta.
0: Journal mensuel
1: Grand Livre des comptes
2: Grand livre des journaux
3:
4:
5: Impression Θcran ''Interrogation d''un compte'''
WHERE (RDB$RELATION_NAME = 'ETATS') AND (RDB$FIELD_NAME = 'NOFONCTION');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''exercice'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date de dΘbut de l''exercice'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'DATEDEB');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date de fin de l''exercice'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'DATEFIN');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Nom convivial de l''exercice'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'DESIGNATION');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne. Ne pas modifier'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'CLOS');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne. Ne pas modifier'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'DATE_CLOTURE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du mouvement contenant les "A Nouveaux" dans l''exercice suivant. '
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'MVT_A_NOUVEAU');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Mouvement "a nouveau" contenant les reports fournisseurs de l''exercice prΘcΘdent'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'MVT_401');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Mouvement "a nouveau" contenant les reports clients de l''exercice prΘcΘdent'
WHERE (RDB$RELATION_NAME = 'EXERCICE') AND (RDB$FIELD_NAME = 'MVT_411');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du Journal'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Description brΦve (exemple: "VT")'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'SHORTDESI');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Description complΦte (exemple: "Journal des ventes")'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'LONGDESI');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Indique le type de Journal:
0: Ventes
1: Achat
2: TrΘsorerie
3: Divers
4: A Nouveaux'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'TYPEJX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Type de numΘrotation automatique des mouvements:
Manuelle
Par mois
Par Journal
Globale'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'NUMEROTATION');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Compte rattachΘ α ce journal. Permet d''indiquer le solde de ce compte durant la saisie des Θcdritures dans le journal'
WHERE (RDB$RELATION_NAME = 'JOURNAL') AND (RDB$FIELD_NAME = 'INDX_COMPTE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du Journal mensuel'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''exercice ( -> EXERCICE.INDX)'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'INDX_EXERCICE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du Journal ( -> JOURNAL.INDX)'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'INDX_JOURNAL');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ d''ordre du mois (0-11)
Sert au tri pour les exercices ouverts en cours d''annΘe.'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'NOMOIS');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ du mois (1-12). '
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'MOIS');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Total des Θcritures pour le compte rattachΘ α ce journal.'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'SOLDE_COMPTE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date de la derniΦre impression'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'DATE_PRN');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne. Ne pas modifier.'
WHERE (RDB$RELATION_NAME = 'JOURNAL_MOIS') AND (RDB$FIELD_NAME = 'DATE_CLOTURE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du mouvement ( ->MOUVEMENTS.INDX)'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'INDX_MVT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ de la ligne (1..n) dans le mouvement'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'LIGNE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''exercice. Permet d''accΘlΘrer certaines requΩtes en Θvitant une jointure avec MOUVEMENTS->INDX_EXERCICE'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'INDXE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du compte'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'INDX_CPT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du compte gΘnΘral si le compte est un compte auxilliaire, sinon copie de INDX_CPT. Permet d''accΘlΘlrer les requΩtes ne portant que sur les comptes gΘnΘraux.'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'INDX_RGP');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Description de somme inscrite dans la ligne d''Θcriture'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'LIBELLE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Montant de l''Θcriture'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'MONTANT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = '"C"=CrΘdit
"D"=DΘbit'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'SENS');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Identifiant du lettrage. Exemple: "A", "AAE" etc....'
WHERE (RDB$RELATION_NAME = 'LIGNES') AND (RDB$FIELD_NAME = 'LETTRAGE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ identifiant le poste ayant gΘnΘrΘ cette liste.'
WHERE (RDB$RELATION_NAME = 'LISTE') AND (RDB$FIELD_NAME = 'NOLISTE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du mouvement.'
WHERE (RDB$RELATION_NAME = 'LISTE') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ de la ligne'
WHERE (RDB$RELATION_NAME = 'LISTE') AND (RDB$FIELD_NAME = 'NOLIGNE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du modΦle'
WHERE (RDB$RELATION_NAME = 'MODELES') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du fichier binaire contenant le modΦle. ( -> BLOBS.INDX)'
WHERE (RDB$RELATION_NAME = 'MODELES') AND (RDB$FIELD_NAME = 'INDX_BLOB');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Description du modΦle.'
WHERE (RDB$RELATION_NAME = 'MODELES') AND (RDB$FIELD_NAME = 'DESIGNATION');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Raccourci clavier affectΘ α ce modΦle.'
WHERE (RDB$RELATION_NAME = 'MODELES') AND (RDB$FIELD_NAME = 'SHORTKEY');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = '1: Indique que ce modΦle est utilisΘ par les Θcritures soldant un lettrage non-nul.'
WHERE (RDB$RELATION_NAME = 'MODELES') AND (RDB$FIELD_NAME = 'ISLETTRAGE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index de l''exercice ( -> EXERCICE.INDX)'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'INDX_EXERCICE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du journal mensuel ( -> JOURNAL_MOIS.INDX)'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'INDX_JOURNAL_M');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date du mouvement'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'DATE_MVT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ du mouvement. La numΘrotation des mouvements est rΘgie par les compteurs.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'NO_INTERNE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'N░ de la commande/facture chez le fournisseur/client. (ImportΘ depuis FastCaisse lors d''une synchronisation)'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'NO_EXTERNE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne (NΘcessaire au respect de la directive 13 L-1-106) . Ne pas modifier ce champ.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'VERROU');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Indique si le mouvement a ΘtΘ imprimΘ depuis sa crΘation/modification.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'PRINTED');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Sert au marquage par couleur des mouvements lors de l''affichage.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'IMPAIRE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Solde progressif du compte rattachΘ au journal rattachΘ au mouvement'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'SOLDE_PROG');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Usage interne (NΘcessaire au respect de la directive 13 L-1-106) . Ne pas modifier ce champ.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'DATE_CLOTURE');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date de l''importation par pont comptable.'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'DATE_PONT');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Date de la derniΦre modification'
WHERE (RDB$RELATION_NAME = 'MOUVEMENTS') AND (RDB$FIELD_NAME = 'DATE_MODIF');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Index du taux.'
WHERE (RDB$RELATION_NAME = 'TVA') AND (RDB$FIELD_NAME = 'INDX');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'DΘsignation conviviale'
WHERE (RDB$RELATION_NAME = 'TVA') AND (RDB$FIELD_NAME = 'DESIGNATION');

UPDATE RDB$RELATION_FIELDS
SET RDB$DESCRIPTION = 'Valeur du taux *100.'
WHERE (RDB$RELATION_NAME = 'TVA') AND (RDB$FIELD_NAME = 'VALEUR');



/* Parameters descriptions */

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Montant de toutes les Θcritures crΘditrices.'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_UN_COMPTE') AND (RDB$PARAMETER_NAME = 'CREDIT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Montant de toutes les Θcritures dΘbitrices.'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_UN_COMPTE') AND (RDB$PARAMETER_NAME = 'DEBIT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index du compte'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_UN_COMPTE') AND (RDB$PARAMETER_NAME = 'INDX_CPT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index de l''exercice'
WHERE (RDB$PROCEDURE_NAME = 'BALANCE_UN_COMPTE') AND (RDB$PARAMETER_NAME = 'INDX_EXERCICE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Lettrage actuel'
WHERE (RDB$PROCEDURE_NAME = 'GET_NEXT_LETTRAGE') AND (RDB$PARAMETER_NAME = 'LETTRAGE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Lettrage suivant'
WHERE (RDB$PROCEDURE_NAME = 'GET_NEXT_LETTRAGE') AND (RDB$PARAMETER_NAME = 'RESULT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = '0: regrouper les comptes Tiers 1: DΘtail pour chaque tiers'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'AVEC_TIERS');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Code du Journal'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'CODEJ');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Montant crΘditeur'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'CREDIT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Date du mouvement'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'DATE_MVT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Montant dΘbiteur'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'DEBIT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = '0: Tous les comptes. n: Compte d''index n seulement'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'INDEX_CPT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index du compte en cours'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'INDX');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index de l''exercice (-> EXERCICE,INDX)'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'INDX_EXERCICE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Lettrage de la ligne d''Θcriture (NULL si ligne non-lettrΘe)'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'LETTRAGE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Description de l''Θcriture'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'LIBELLE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'LibellΘ du compte tiers'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'LIB_AUXI');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'LibellΘ du compte gΘnΘral'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'LIB_GENE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'N░ original de la piΦce (N░ de facture, de ticket, etc)'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'NO_EXTERNE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'N░ de la piΦce (numΘrotation)'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'NO_INTERNE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = '1: Seulement les Θcritures lettrΘes'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'QUE_LETTRE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = '1: Seulement les Θcritures non-lettrΘes '
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'QUE_NON_LETTRE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Solde progressif du compte (=somme des montants prΘcΘdents)'
WHERE (RDB$PROCEDURE_NAME = 'GRAND_LIVRE') AND (RDB$PARAMETER_NAME = 'SOLDEP');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Code du Journal'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_CPT') AND (RDB$PARAMETER_NAME = 'CODEJ');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Date du mouvement'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_CPT') AND (RDB$PARAMETER_NAME = 'DATE_MVT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index du compte auxilliaire'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_CPT') AND (RDB$PARAMETER_NAME = 'INDX_CPT');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = 'Index de l''exercice (-> EXERCICE.INDX)'
WHERE (RDB$PROCEDURE_NAME = 'INTERROGATION_CPT') AND (RDB$PARAMETER_NAME = 'INDX_EXERCICE');

UPDATE RDB$PROCEDURE_PARAMETERS
SET RDB$DESCRIPTION = '0: Tous  1: MouvementΘ  2: MouvementΘ plus un vide'
WHERE (RDB$PROCEDURE_NAME = 'LISTE_JOURNAUX_MENSUELS') AND (RDB$PARAMETER_NAME = 'TYPE_LISTE');

COMMIT WORK;